select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and a.houseType = 3 and (b.cnpropertyname like '%Fortune Residence%' or b.enpropertyname like '%Fortune Residence%') order by updateTime Desc, a.dftpic desc
This is an amazing apt, it was newly renovated, luxury decoration with bright and spacious livingroom and bedrooms, whole house floor heating and wall heating, ...